Problem Note 19868: Oracle prepare error running summation query in SAS® Enterprise Guide®
The following error might be generated when running certain summation
type queries using SAS Enterprise Guide:
ERROR: ORACLE prepare error: ORA-00923: FROM keyword not found
where expected.
The problem will most likely occur if an Oracle table or table from
another non-SAS database is being queried and the query contains a
summation function, or the column name contains embedded spaces.
To circumvent the problem, manually add the summation fuction using
the Expression window in the Query Builder; for example:
sum(distinct(table_name.'var_name'n))
Operating System and Release Information
SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2007-05-11 16:58:24 |
Date Created: | 2007-03-28 17:16:17 |